﻿create proc usp_ExamCategories_Insert 
@id  uniqueidentifier ,  
@Title varchar(500), 
@Description varchar(4000)
as 
insert into ExamCategories (id, title, [description]) values(@id,@Title,@Description)

go 
create proc usp_ExamCategories_Update
@id  uniqueidentifier ,  
@Title varchar(500), 
@Description varchar(4000)
as
update ExamCategories set Title = @title, [Description]=@Description where id =@id
go
create proc usp_ExamCategories_Delete
@id  uniqueidentifier 
as
delete  ExamCategories where Id = @id
go
create proc usp_ExamCategories_GetOne
@id  uniqueidentifier 
as
select * from ExamCategories where Id = @id 
go
create proc usp_ExamCategories_GetAll 
as 
select * from  ExamCategories 

